prepare("SELECT * FROM members WHERE sn=$id"); $sql->execute() ; if($sql->rowcount() == 1) { $row = $sql->fetch(pdo::FETCH_ASSOC) ; $names = $row['names'] ; //$uc = $row['unic_id'] ; $upd = $DBcon->prepare("update members set status = 'ACTIVE' WHERE sn =$id") ; if($upd->execute()) $success = "ACCOUNT ACTIVATE SUCCESSFULLY" ; } else { $msgx = "Your Account is not found, try again" ; } } if(isset($_POST['submit'])) { $city = trim($_POST['city']) ; $st = trim($_POST['st']) ; $country = trim($_POST['country']) ; $Destination = 'uploads'; if(!isset($_FILES['file']) || !is_uploaded_file($_FILES['file']['tmp_name'])) { $msg[] = 'Please Browse and Select the picture Before Uploading' ; } // Check file size $RandomNum = rand(0, 9999999999); $ImageName = str_replace(' ','-',strtolower($_FILES['file']['name'])); $ImageType = $_FILES['file']['type']; //"image/png", image/jpeg etc. $ImageExt = substr($ImageName, strrpos($ImageName, '.')); $ImageExt = str_replace('.','',$ImageExt); $ImageName = preg_replace("/\.[^.\s]{3,4}$/", "", $ImageName); //Create new image name (with random number added). $NewImageName = $ImageName.'-'.$RandomNum.'.'.$ImageExt; if(empty($msg)) { if( move_uploaded_file($_FILES['file']['tmp_name'], "$Destination/$NewImageName")) { $sql = $DBcon->prepare("update members set image = '$NewImageName',city =:ct, state=:st, country =:ctry where sn =:id") ; $sql->bindparam(":id",$id) ; $sql->bindparam(":ct",$city) ; $sql->bindparam(":st",$st) ; $sql->bindparam(":ctry",$country) ; $sql->execute() ; $_SESSION['imgname'] = $NewImageName ; $msg[] = 'Picture Uploaded Successfully' ; header("Refresh: 5; url=card1.php?id=$id"); } else { $msg[] = 'Some thing went long while Uploading Your Picture, Make sure the Picture is not too Large and try again' ; } } } ?> ACTIVATION

ACTIVATING ACCOUNT

ACTIVATING ACCOUNT

'; foreach ($msg as $item) { echo "
  • $item
    • "; } echo ''; } ?>